Mysql 对数字的格式化和补0

您所在的位置：网站首页 › mysql 字符串转数字写入一个字段怎么弄出来 › Mysql 对数字的格式化和补0

Mysql 对数字的格式化和补0

2024-07-03 14:50| 来源: 网络整理| 查看: 265

format函数：格式化浮点数 format(number, length);

Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. If D is 0, the result has no decimal point or fractional part. D should be a constant value.

mysql> SELECT FORMAT(12332.123456, 4); -> '12,332.1235' mysql> SELECT FORMAT(12332.1,4); -> '12,332.1000' mysql> SELECT FORMAT(12332.2,0); -> '12,332'rpad 和 lpad 给定位数，不足补充自定义字符RPAD:Returns the string str,right-padded with the string padstr to a length of len characters. Ifstr is longer than len, the return value is shortened to len characters.

mysql> SELECT RPAD('hi',5,'?'); -> 'hi???' mysql> SELECT RPAD('hi',1,'?'); -> 'h'mysql>SELET RPAD(12, 5 ,0); ->12000

This function is multi-byte safe.

LPAD:

Returns the string str, left-padded with the string padstr to a length of lencharacters. If str is longer than len, the return value is shortened to lencharacters.

mysql> SELECT LPAD('hi',4,'??'); -> '??hi' mysql> SELECT LPAD('hi',1,'??'); -> 'h'

mysql>SELECT LPAD(12, 5 , 0) ->'00012'

【本文地址】

Mysql 对数字的格式化和补0

Mysql 对数字的格式化和补0

今日新闻

推荐新闻